home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vbatchadjust.sql < prev    next >
Text File  |  2000-05-12  |  429b  |  13 lines
  1. /*
  2. sums the batch adjustments for a given batch total sequence number. Outer join is to 
  3. ensure that there is a record for the vcbcount view to process
  4. */
  5. create or replace view vbatchadjust as
  6. select sum(total_adjust) batch_adjust,
  7.     batchtotals.batch_total_seq_num 
  8. from adjustment , 
  9.     batchtotals
  10. where adjustment.batch_total_seq_num (+) = batchtotals.batch_total_seq_num
  11. group by batchtotals.batch_total_seq_num;
  12.  
  13.